﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;

/// <summary>
/// Summary description for connection
/// </summary>
public class connection
{
	public connection()
	{
        
	}

    public SqlConnection connect()
    {
        string connStr = ConfigurationManager.ConnectionStrings["canhbuomxanhconnectionstring"].ConnectionString;
        SqlConnection mySQLconnection = new SqlConnection(connStr);
        if (mySQLconnection.State == ConnectionState.Closed)
        {
            mySQLconnection.Open();
        }
        return mySQLconnection;
    }
}